Profiling Report

Dataset statistics

Number of variables	43
Number of observations	28953
Missing cells	501215
Missing cells (%)	40.3%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	9.5 MiB
Average record size in memory	344.0 B

Variable types

Unsupported	5
Categorical	20
Numeric	18

Alerts

`CEOANN` has constant value ""	Constant
`PCEO` has constant value ""	Constant
`PCFO` has constant value ""	Constant
`CONAME` has a high cardinality: 386 distinct values	High cardinality
`COMMENT` has a high cardinality: 1413 distinct values	High cardinality
`BECAMECEO` has a high cardinality: 559 distinct values	High cardinality
`JOINED_CO` has a high cardinality: 564 distinct values	High cardinality
`LEFTOFC` has a high cardinality: 659 distinct values	High cardinality
`LEFTCO` has a high cardinality: 780 distinct values	High cardinality
`TITLE` has a high cardinality: 2655 distinct values	High cardinality
`EXEC_LNAME` has a high cardinality: 3976 distinct values	High cardinality
`EXEC_FNAME` has a high cardinality: 811 distinct values	High cardinality
`CUSIP` has a high cardinality: 386 distinct values	High cardinality
`TICKER` has a high cardinality: 386 distinct values	High cardinality
`REPRICE` is highly imbalanced (96.2%)	Imbalance
`GENDER` is highly imbalanced (76.1%)	Imbalance
`CFOANN` has 28953 (100.0%) missing values	Missing
`EXECRANK` has 28747 (99.3%) missing values	Missing
`CEOANN` has 24685 (85.3%) missing values	Missing
`PENSION_CHG` has 28953 (100.0%) missing values	Missing
`TOTAL_SEC` has 28953 (100.0%) missing values	Missing
`CHG_CTRL_PYMT` has 28953 (100.0%) missing values	Missing
`AGE` has 18708 (64.6%) missing values	Missing
`EXECRANKANN` has 7094 (24.5%) missing values	Missing
`TDC1` has 4801 (16.6%) missing values	Missing
`SAL_PCT` has 5288 (18.3%) missing values	Missing
`TOTAL_CURR_PCT` has 5283 (18.2%) missing values	Missing
`TOTAL_SEC_PCT` has 28953 (100.0%) missing values	Missing
`TDC1_PCT` has 10584 (36.6%) missing values	Missing
`COMMENT` has 26778 (92.5%) missing values	Missing
`BECAMECEO` has 20979 (72.5%) missing values	Missing
`JOINED_CO` has 19336 (66.8%) missing values	Missing
`REJOIN` has 28787 (99.4%) missing values	Missing
`LEFTOFC` has 21623 (74.7%) missing values	Missing
`LEFTCO` has 20082 (69.4%) missing values	Missing
`RELEFT` has 28883 (99.8%) missing values	Missing
`PCEO` has 28285 (97.7%) missing values	Missing
`PCFO` has 28858 (99.7%) missing values	Missing
`REASON` has 20141 (69.6%) missing values	Missing
`PAGE` has 7491 (25.9%) missing values	Missing
`TDC1` is highly skewed (γ1 = 26.79319677)	Skewed
`ALLOTHTOT` is highly skewed (γ1 = 45.88204098)	Skewed
`ALLOTHPD` is highly skewed (γ1 = 61.41823403)	Skewed
`SAL_PCT` is highly skewed (γ1 = 64.95114336)	Skewed
`TOTAL_CURR_PCT` is highly skewed (γ1 = 39.72659118)	Skewed
`TDC1_PCT` is highly skewed (γ1 = 64.95675232)	Skewed
`CFOANN` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`PENSION_CHG` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`TOTAL_SEC` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`CHG_CTRL_PYMT` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`TOTAL_SEC_PCT` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`BONUS` has 2849 (9.8%) zeros	Zeros
`ALLOTHTOT` has 2466 (8.5%) zeros	Zeros
`ALLOTHPD` has 26385 (91.1%) zeros	Zeros
`SAL_PCT` has 2347 (8.1%) zeros	Zeros
`TOTAL_CURR_PCT` has 424 (1.5%) zeros	Zeros

Reproduction

Analysis started	2023-04-27 19:12:41.593834
Analysis finished	2023-04-27 19:13:39.287706
Duration	57.69 seconds
Software version	ydata-profiling vv4.0.0
Download configuration	config.json

CFOANN
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	28953
Missing (%)	100.0%
Memory size	226.3 KiB

EXECDIR
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	226.3 KiB

0	19666
1	9287

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	28953
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	19666	67.9%
1	9287	32.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	19666	67.9%
1	9287	32.1%

Most occurring characters

Value	Count	Frequency (%)
0	19666	67.9%
1	9287	32.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	28953	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	19666	67.9%
1	9287	32.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	28953	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	19666	67.9%
1	9287	32.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	28953	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	19666	67.9%
1	9287	32.1%

REPRICE
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	226.3 KiB

0	28836
1	117

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	28953
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	28836	99.6%
1	117	0.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	28836	99.6%
1	117	0.4%

Most occurring characters

Value	Count	Frequency (%)
0	28836	99.6%
1	117	0.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	28953	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	28836	99.6%
1	117	0.4%

Most occurring scripts

Value	Count	Frequency (%)
Common	28953	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	28836	99.6%
1	117	0.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	28953	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	28836	99.6%
1	117	0.4%

EXECRANK
Real number (ℝ)

Distinct	7
Distinct (%)	3.4%
Missing	28747
Missing (%)	99.3%
Infinite	0
Infinite (%)	0.0%
Mean	2.4368932

Minimum	1
Maximum	7
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	226.3 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	2
Q3	3
95-th percentile	6
Maximum	7
Range	6
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.7372246
Coefficient of variation (CV)	0.712885
Kurtosis	-0.16554224
Mean	2.4368932
Median Absolute Deviation (MAD)	1
Skewness	1.0202751
Sum	502
Variance	3.0179493
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
1	93	0.3%
2	38	0.1%
3	24	0.1%
5	17	0.1%
4	16	0.1%
6	14	< 0.1%
7	4	< 0.1%
(Missing)	28747	99.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	93	0.3%
2	38	0.1%
3	24	0.1%
4	16	0.1%
5	17	0.1%
6	14	< 0.1%
7	4	< 0.1%

Value	Count	Frequency (%)
7	4	< 0.1%
6	14	< 0.1%
5	17	0.1%
4	16	0.1%
3	24	0.1%
2	38	0.1%
1	93	0.3%

CO_PER_ROL
Real number (ℝ)

Distinct	5173
Distinct (%)	17.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	13451.388

Minimum	1
Maximum	36815
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	226.3 KiB

Quantile statistics

Minimum	1
5-th percentile	702
Q1	3914
median	13342
Q3	21541
95-th percentile	28917
Maximum	36815
Range	36814
Interquartile range (IQR)	17627

Descriptive statistics

Standard deviation	9627.1892
Coefficient of variation (CV)	0.71570228
Kurtosis	-1.2503652
Mean	13451.388
Median Absolute Deviation (MAD)	8980
Skewness	0.18137482
Sum	3.8945804 × 10⁸
Variance	92682772
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2593	14	< 0.1%
7995	14	< 0.1%
2865	14	< 0.1%
3816	14	< 0.1%
3817	14	< 0.1%
6562	14	< 0.1%
6564	14	< 0.1%
2816	14	< 0.1%
3861	14	< 0.1%
7996	14	< 0.1%
Other values (5163)	28813	99.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	7	< 0.1%
2	10	< 0.1%
3	12	< 0.1%
4	11	< 0.1%
5	3	< 0.1%
6	7	< 0.1%
7	7	< 0.1%
8	9	< 0.1%
9	3	< 0.1%
10	6	< 0.1%

Value	Count	Frequency (%)
36815	2	< 0.1%
36813	1	< 0.1%
36804	2	< 0.1%
36803	2	< 0.1%
36802	5	< 0.1%
36730	3	< 0.1%
36729	4	< 0.1%
36728	4	< 0.1%
36188	5	< 0.1%
36186	2	< 0.1%

CONAME
Categorical

Distinct	386
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Memory size	226.3 KiB

PG&E CORP	138
EDISON INTERNATIONAL	124
SCHWAB (CHARLES) CORP	118
CONOCOPHILLIPS	112
FORD MOTOR CO	111
Other values (381)	28350

Length

Max length	28
Median length	21
Mean length	16.821228
Min length	5

Characters and Unicode

Total characters	487025
Distinct characters	36
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	AMERICAN AIRLINES GROUP INC
2nd row	AMERICAN AIRLINES GROUP INC
3rd row	AMERICAN AIRLINES GROUP INC
4th row	AMERICAN AIRLINES GROUP INC
5th row	AMERICAN AIRLINES GROUP INC

Common Values

Value	Count	Frequency (%)
PG&E CORP	138	0.5%
EDISON INTERNATIONAL	124	0.4%
SCHWAB (CHARLES) CORP	118	0.4%
CONOCOPHILLIPS	112	0.4%
FORD MOTOR CO	111	0.4%
CMS ENERGY CORP	109	0.4%
MICRON TECHNOLOGY INC	108	0.4%
AMERICAN INTERNATIONAL GROUP	107	0.4%
EXELON CORP	106	0.4%
WILLIAMS COS INC	106	0.4%
Other values (376)	27814	96.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
inc	12909	16.0%
corp	7891	9.8%
co	3839	4.7%
	1734	2.1%
energy	1348	1.7%
group	1311	1.6%
plc	865	1.1%
financial	728	0.9%
intl	685	0.8%
technologies	675	0.8%
Other values (546)	48917	60.5%

Most occurring characters

Value	Count	Frequency (%)
	52222	10.7%
C	44637	9.2%
N	41102	8.4%
O	39829	8.2%
E	37988	7.8%
I	36702	7.5%
R	36678	7.5%
A	29244	6.0%
S	22407	4.6%
L	22142	4.5%
Other values (26)	124074	25.5%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	428145	87.9%
Space Separator	52222	10.7%
Other Punctuation	2710	0.6%
Dash Punctuation	1435	0.3%
Open Punctuation	1150	0.2%
Close Punctuation	1150	0.2%
Decimal Number	213	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
C	44637	10.4%
N	41102	9.6%
O	39829	9.3%
E	37988	8.9%
I	36702	8.6%
R	36678	8.6%
A	29244	6.8%
S	22407	5.2%
L	22142	5.2%
T	21915	5.1%
Other values (16)	95501	22.3%

Other Punctuation

Value	Count	Frequency (%)
&	2053	75.8%
'	290	10.7%
.	267	9.9%
/	100	3.7%

Decimal Number

Value	Count	Frequency (%)
3	191	89.7%
5	22	10.3%

Space Separator

Value	Count	Frequency (%)
	52222	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	1435	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	1150	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	1150	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	428145	87.9%
Common	58880	12.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
C	44637	10.4%
N	41102	9.6%
O	39829	9.3%
E	37988	8.9%
I	36702	8.6%
R	36678	8.6%
A	29244	6.8%
S	22407	5.2%
L	22142	5.2%
T	21915	5.1%
Other values (16)	95501	22.3%

Common

Value	Count	Frequency (%)
	52222	88.7%
&	2053	3.5%
-	1435	2.4%
(	1150	2.0%
)	1150	2.0%
'	290	0.5%
.	267	0.5%
3	191	0.3%
/	100	0.2%
5	22	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	487025	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	52222	10.7%
C	44637	9.2%
N	41102	8.4%
O	39829	8.2%
E	37988	7.8%
I	36702	7.5%
R	36678	7.5%
A	29244	6.0%
S	22407	4.6%
L	22142	4.5%
Other values (26)	124074	25.5%

CEOANN
Categorical

CONSTANT MISSING

Distinct	1
Distinct (%)	< 0.1%
Missing	24685
Missing (%)	85.3%
Memory size	226.3 KiB

CEO	4268

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	12804
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	CEO
2nd row	CEO
3rd row	CEO
4th row	CEO
5th row	CEO

Common Values

Value	Count	Frequency (%)
CEO	4268	14.7%
(Missing)	24685	85.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
ceo	4268	100.0%

Most occurring characters

Value	Count	Frequency (%)
C	4268	33.3%
E	4268	33.3%
O	4268	33.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	12804	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
C	4268	33.3%
E	4268	33.3%
O	4268	33.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	12804	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
C	4268	33.3%
E	4268	33.3%
O	4268	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	12804	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
C	4268	33.3%
E	4268	33.3%
O	4268	33.3%

SALARY
Real number (ℝ)

Distinct	14776
Distinct (%)	51.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	451.39446

Minimum	-0.0001
Maximum	6765
Zeros	66
Zeros (%)	0.2%
Negative	1
Negative (%)	< 0.1%
Memory size	226.3 KiB

Quantile statistics

Minimum	-0.0001
5-th percentile	143.3966
Q1	255.221
median	375
Q3	553
95-th percentile	1000
Maximum	6765
Range	6765.0001
Interquartile range (IQR)	297.779

Descriptive statistics

Standard deviation	314.85195
Coefficient of variation (CV)	0.69750956
Kurtosis	33.500736
Mean	451.39446
Median Absolute Deviation (MAD)	137.5
Skewness	3.6453475
Sum	13069224
Variance	99131.752
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
300	385	1.3%
400	318	1.1%
1000	302	1.0%
500	293	1.0%
600	263	0.9%
450	244	0.8%
350	223	0.8%
250	207	0.7%
200	189	0.7%
800	152	0.5%
Other values (14766)	26377	91.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-0.0001	1	< 0.1%
0	66	0.2%
0.001	30	0.1%
0.827	1	< 0.1%
1.923	1	< 0.1%
2.02	1	< 0.1%
2.223	2	< 0.1%
2.363	1	< 0.1%
2.418	1	< 0.1%
4.615	1	< 0.1%

Value	Count	Frequency (%)
6765	1	< 0.1%
5806.651	1	< 0.1%
5773.077	1	< 0.1%
5306.651	1	< 0.1%
5294.095	1	< 0.1%
4973.073	1	< 0.1%
4600	1	< 0.1%
4476.101	1	< 0.1%
4395.697	1	< 0.1%
4309.092	1	< 0.1%

BONUS
Real number (ℝ)

Distinct	14343
Distinct (%)	49.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	559.16719

Minimum	0
Maximum	43511.534
Zeros	2849
Zeros (%)	9.8%
Negative	0
Negative (%)	0.0%
Memory size	226.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	111.665
median	260.825
Q3	557.376
95-th percentile	1978.92
Maximum	43511.534
Range	43511.534
Interquartile range (IQR)	445.711

Descriptive statistics

Standard deviation	1195.9494
Coefficient of variation (CV)	2.1388047
Kurtosis	164.18055
Mean	559.16719
Median Absolute Deviation (MAD)	189.175
Skewness	9.5003975
Sum	16189568
Variance	1430295
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2849	9.8%
300	272	0.9%
500	229	0.8%
200	225	0.8%
250	205	0.7%
100	204	0.7%
400	203	0.7%
350	196	0.7%
150	193	0.7%
600	161	0.6%
Other values (14333)	24216	83.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2849	9.8%
0.026	1	< 0.1%
0.2	1	< 0.1%
0.25	2	< 0.1%
0.3	2	< 0.1%
0.4	1	< 0.1%
0.428	1	< 0.1%
0.5	1	< 0.1%
0.7	11	< 0.1%
0.759	1	< 0.1%

Value	Count	Frequency (%)
43511.534	1	< 0.1%
33000	1	< 0.1%
29000	1	< 0.1%
26640.502	1	< 0.1%
26000	1	< 0.1%
23618.156	1	< 0.1%
22900.821	1	< 0.1%
22000	1	< 0.1%
21519.6	1	< 0.1%
20272.096	1	< 0.1%

PENSION_CHG
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	28953
Missing (%)	100.0%
Memory size	226.3 KiB

TOTAL_SEC
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	28953
Missing (%)	100.0%
Memory size	226.3 KiB

TOTAL_CURR
Real number (ℝ)

Distinct	22315
Distinct (%)	77.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1010.5616

Minimum	-0.0001
Maximum	43511.535
Zeros	52
Zeros (%)	0.2%
Negative	1
Negative (%)	< 0.1%
Memory size	226.3 KiB

Quantile statistics

Minimum	-0.0001
5-th percentile	203.0792
Q1	407.394
median	653.533
Q3	1109.225
95-th percentile	2845.833
Maximum	43511.535
Range	43511.535
Interquartile range (IQR)	701.831

Descriptive statistics

Standard deviation	1361.38
Coefficient of variation (CV)	1.3471519
Kurtosis	110.62735
Mean	1010.5616
Median Absolute Deviation (MAD)	302.7
Skewness	7.6558172
Sum	29258791
Variance	1853355.6
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
500	71	0.2%
1000	66	0.2%
550	66	0.2%
800	66	0.2%
600	64	0.2%
450	64	0.2%
750	62	0.2%
700	62	0.2%
0	52	0.2%
400	48	0.2%
Other values (22305)	28332	97.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-0.0001	1	< 0.1%
0	52	0.2%
0.001	19	0.1%
1.631	2	< 0.1%
1.724	1	< 0.1%
2.223	2	< 0.1%
2.363	1	< 0.1%
2.418	1	< 0.1%
4.615	1	< 0.1%
6.231	1	< 0.1%

Value	Count	Frequency (%)
43511.535	1	< 0.1%
34000	1	< 0.1%
30000	1	< 0.1%
27998.838	1	< 0.1%
27000	1	< 0.1%
23957.5	1	< 0.1%
23550.821	1	< 0.1%
22519.6	1	< 0.1%
22450.137	1	< 0.1%
21906	1	< 0.1%

CHG_CTRL_PYMT
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	28953
Missing (%)	100.0%
Memory size	226.3 KiB

AGE
Real number (ℝ)

Distinct	60
Distinct (%)	0.6%
Missing	18708
Missing (%)	64.6%
Infinite	0
Infinite (%)	0.0%
Mean	54.363202

Minimum	28
Maximum	87
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	226.3 KiB

Quantile statistics

Minimum	28
5-th percentile	42
Q1	49
median	55
Q3	59
95-th percentile	66
Maximum	87
Range	59
Interquartile range (IQR)	10

Descriptive statistics

Standard deviation	7.7443882
Coefficient of variation (CV)	0.14245644
Kurtosis	0.55546124
Mean	54.363202
Median Absolute Deviation (MAD)	5
Skewness	0.15507555
Sum	556951
Variance	59.975549
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
56	544	1.9%
54	543	1.9%
55	538	1.9%
58	535	1.8%
57	532	1.8%
52	511	1.8%
59	506	1.7%
53	501	1.7%
51	467	1.6%
60	457	1.6%
Other values (50)	5111	17.7%
(Missing)	18708	64.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
28	1	< 0.1%
29	2	< 0.1%
30	2	< 0.1%
31	6	< 0.1%
32	6	< 0.1%
33	7	< 0.1%
34	18	0.1%
35	20	0.1%
36	29	0.1%
37	44	0.2%

Value	Count	Frequency (%)
87	1	< 0.1%
86	2	< 0.1%
85	2	< 0.1%
84	3	< 0.1%
83	5	< 0.1%
82	7	< 0.1%
81	12	< 0.1%
80	14	< 0.1%
79	14	< 0.1%
78	15	0.1%

EXECRANKANN
Real number (ℝ)

Distinct	12
Distinct (%)	0.1%
Missing	7094
Missing (%)	24.5%
Infinite	0
Infinite (%)	0.0%
Mean	3.1344069

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	226.3 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	3
Q3	4
95-th percentile	6
Maximum	12
Range	11
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.564356
Coefficient of variation (CV)	0.49909157
Kurtosis	-0.70116284
Mean	3.1344069
Median Absolute Deviation (MAD)	1
Skewness	0.25205962
Sum	68515
Variance	2.4472098
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
1	4275	14.8%
2	4249	14.7%
3	4131	14.3%
4	4089	14.1%
5	4019	13.9%
6	860	3.0%
7	177	0.6%
8	41	0.1%
9	13	< 0.1%
11	2	< 0.1%
Other values (2)	3	< 0.1%
(Missing)	7094	24.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	4275	14.8%
2	4249	14.7%
3	4131	14.3%
4	4089	14.1%
5	4019	13.9%
6	860	3.0%
7	177	0.6%
8	41	0.1%
9	13	< 0.1%
10	2	< 0.1%

Value	Count	Frequency (%)
12	1	< 0.1%
11	2	< 0.1%
10	2	< 0.1%
9	13	< 0.1%
8	41	0.1%
7	177	0.6%
6	860	3.0%
5	4019	13.9%
4	4089	14.1%
3	4131	14.3%

TDC1
Real number (ℝ)

MISSING SKEWED

Distinct	23856
Distinct (%)	98.8%
Missing	4801
Missing (%)	16.6%
Infinite	0
Infinite (%)	0.0%
Mean	3348.4942

Minimum	-0.0001
Maximum	600347.35
Zeros	3
Zeros (%)	< 0.1%
Negative	1
Negative (%)	< 0.1%
Memory size	226.3 KiB

Quantile statistics

Minimum	-0.0001
5-th percentile	311.12595
Q1	803.44075
median	1599.531
Q3	3394.6737
95-th percentile	11447.112
Maximum	600347.35
Range	600347.35
Interquartile range (IQR)	2591.233

Descriptive statistics

Standard deviation	7718.9535
Coefficient of variation (CV)	2.3052014
Kurtosis	1616.7014
Mean	3348.4942
Median Absolute Deviation (MAD)	993.442
Skewness	26.793197
Sum	80872832
Variance	59582243
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.001	11	< 0.1%
100	8	< 0.1%
122.5	6	< 0.1%
108.2	5	< 0.1%
314	5	< 0.1%
300	4	< 0.1%
3716.024	4	< 0.1%
81.84	4	< 0.1%
250	4	< 0.1%
200	4	< 0.1%
Other values (23846)	24097	83.2%
(Missing)	4801	16.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-0.0001	1	< 0.1%
0	3	< 0.1%
0.001	11	< 0.1%
1.32	1	< 0.1%
4.615	1	< 0.1%
8.654	1	< 0.1%
11.336	1	< 0.1%
20	2	< 0.1%
20.796	1	< 0.1%
21.923	1	< 0.1%

Value	Count	Frequency (%)
600347.351	1	< 0.1%
230033.652	1	< 0.1%
204489.424	1	< 0.1%
202185.14	1	< 0.1%
176279.53	1	< 0.1%
159309.275	1	< 0.1%
147586.945	1	< 0.1%
140918.266	1	< 0.1%
137669.87	1	< 0.1%
137669.317	1	< 0.1%

ALLOTHTOT
Real number (ℝ)

SKEWED ZEROS

Distinct	18645
Distinct (%)	64.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	114.0286

Minimum	0
Maximum	95195.5
Zeros	2466
Zeros (%)	8.5%
Negative	0
Negative (%)	0.0%
Memory size	226.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	6
median	17.364
Q3	50.864
95-th percentile	270.7228
Maximum	95195.5
Range	95195.5
Interquartile range (IQR)	44.864

Descriptive statistics

Standard deviation	998.75688
Coefficient of variation (CV)	8.7588281
Kurtosis	3369.1492
Mean	114.0286
Median Absolute Deviation (MAD)	14.377
Skewness	45.882041
Sum	3301470
Variance	997515.31
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2466	8.5%
1.5	218	0.8%
6	187	0.6%
8	148	0.5%
4.8	110	0.4%
10	88	0.3%
9	87	0.3%
5	82	0.3%
5.1	78	0.3%
7.5	76	0.3%
Other values (18635)	25413	87.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2466	8.5%
0.003	3	< 0.1%
0.025	1	< 0.1%
0.03	1	< 0.1%
0.034	1	< 0.1%
0.039	1	< 0.1%
0.066	1	< 0.1%
0.069	2	< 0.1%
0.073	1	< 0.1%
0.074	1	< 0.1%

Value	Count	Frequency (%)
95195.5	1	< 0.1%
48922.949	1	< 0.1%
40484.594	1	< 0.1%
36479.425	1	< 0.1%
33688.97	1	< 0.1%
33684.634	1	< 0.1%
28978.755	1	< 0.1%
22706.15	1	< 0.1%
22006.1	1	< 0.1%
21859.386	1	< 0.1%

ALLOTHPD
Real number (ℝ)

SKEWED ZEROS

Distinct	2033
Distinct (%)	7.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	49.674424

Minimum	0
Maximum	95107.134
Zeros	26385
Zeros (%)	91.1%
Negative	0
Negative (%)	0.0%
Memory size	226.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	27.2476
Maximum	95107.134
Range	95107.134
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	879.16354
Coefficient of variation (CV)	17.698515
Kurtosis	5444.9111
Mean	49.674424
Median Absolute Deviation (MAD)	0
Skewness	61.418234
Sum	1438223.6
Variance	772928.52
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	26385	91.1%
6	21	0.1%
50	17	0.1%
100	16	0.1%
26	16	0.1%
1	15	0.1%
12.5	14	< 0.1%
1.5	13	< 0.1%
8.4	12	< 0.1%
12	12	< 0.1%
Other values (2023)	2432	8.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	26385	91.1%
0.05	2	< 0.1%
0.066	1	< 0.1%
0.1	1	< 0.1%
0.115	1	< 0.1%
0.128	1	< 0.1%
0.137	1	< 0.1%
0.15	2	< 0.1%
0.153	1	< 0.1%
0.18	1	< 0.1%

Value	Count	Frequency (%)
95107.134	1	< 0.1%
48917.997	1	< 0.1%
40484.594	1	< 0.1%
33688.97	1	< 0.1%
33684.634	1	< 0.1%
28960.132	1	< 0.1%
21859.386	1	< 0.1%
17687.141	1	< 0.1%
17067.987	1	< 0.1%
16448.276	1	< 0.1%

SAL_PCT
Real number (ℝ)

MISSING SKEWED ZEROS

Distinct	12653
Distinct (%)	53.5%
Missing	5288
Missing (%)	18.3%
Infinite	0
Infinite (%)	0.0%
Mean	24.274287

Minimum	-100
Maximum	25897.582
Zeros	2347
Zeros (%)	8.1%
Negative	1250
Negative (%)	4.3%
Memory size	226.3 KiB

Quantile statistics

Minimum	-100
5-th percentile	-0.1848
Q1	3.392
median	6.897
Q3	14.016
95-th percentile	45.8126
Maximum	25897.582
Range	25997.582
Interquartile range (IQR)	10.624

Descriptive statistics

Standard deviation	293.56048
Coefficient of variation (CV)	12.093475
Kurtosis	5313.7345
Mean	24.274287
Median Absolute Deviation (MAD)	4.862
Skewness	64.951143
Sum	574451.01
Variance	86177.758
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2347	8.1%
5	156	0.5%
10	140	0.5%
4	107	0.4%
11.111	106	0.4%
5.263	86	0.3%
12.5	75	0.3%
7.143	74	0.3%
6.667	74	0.3%
14.286	71	0.2%
Other values (12643)	20429	70.6%
(Missing)	5288	18.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-100	11	< 0.1%
-99.999	2	< 0.1%
-99.998	2	< 0.1%
-98.485	1	< 0.1%
-96.217	1	< 0.1%
-94.494	1	< 0.1%
-93.675	1	< 0.1%
-92.334	1	< 0.1%
-91.923	1	< 0.1%
-91.912	1	< 0.1%

Value	Count	Frequency (%)
25897.582	1	< 0.1%
25890.099	1	< 0.1%
12650.494	1	< 0.1%
8275.295	1	< 0.1%
7100.461	1	< 0.1%
6736.213	1	< 0.1%
5600	1	< 0.1%
5386.542	1	< 0.1%
4410.703	1	< 0.1%
4098.794	1	< 0.1%

TOTAL_CURR_PCT
Real number (ℝ)

MISSING SKEWED ZEROS

Distinct	19458
Distinct (%)	82.2%
Missing	5283
Missing (%)	18.2%
Infinite	0
Infinite (%)	0.0%
Mean	30.972142

Minimum	-100
Maximum	16361.776
Zeros	424
Zeros (%)	1.5%
Negative	5778
Negative (%)	20.0%
Memory size	226.3 KiB

Quantile statistics

Minimum	-100
5-th percentile	-33.85755
Q1	0
median	11.0595
Q3	29.39175
95-th percentile	103.70755
Maximum	16361.776
Range	16461.776
Interquartile range (IQR)	29.39175

Descriptive statistics

Standard deviation	227.17823
Coefficient of variation (CV)	7.3349214
Kurtosis	2345.8265
Mean	30.972142
Median Absolute Deviation (MAD)	13.9405
Skewness	39.726591
Sum	733110.6
Variance	51609.947
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	424	1.5%
10	30	0.1%
7.143	26	0.1%
5	23	0.1%
8.333	22	0.1%
11.111	20	0.1%
16.667	20	0.1%
9.091	19	0.1%
14.286	19	0.1%
20	19	0.1%
Other values (19448)	23048	79.6%
(Missing)	5283	18.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-100	12	< 0.1%
-99.999	1	< 0.1%
-98.907	1	< 0.1%
-98.035	1	< 0.1%
-96.923	1	< 0.1%
-96.4	1	< 0.1%
-96.195	1	< 0.1%
-95.117	1	< 0.1%
-95.037	1	< 0.1%
-94.975	1	< 0.1%

Value	Count	Frequency (%)
16361.776	1	< 0.1%
15888.314	1	< 0.1%
7819.747	1	< 0.1%
6713.052	1	< 0.1%
6017.611	1	< 0.1%
5640.907	1	< 0.1%
5406.47	1	< 0.1%
5047.943	1	< 0.1%
4708.101	1	< 0.1%
4464.789	1	< 0.1%

TOTAL_SEC_PCT
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	28953
Missing (%)	100.0%
Memory size	226.3 KiB

TDC1_PCT
Real number (ℝ)

MISSING SKEWED

Distinct	17364
Distinct (%)	94.5%
Missing	10584
Missing (%)	36.6%
Infinite	0
Infinite (%)	0.0%
Mean	57.279147

Minimum	-100
Maximum	61584.348
Zeros	31
Zeros (%)	0.1%
Negative	6646
Negative (%)	23.0%
Memory size	226.3 KiB

Quantile statistics

Minimum	-100
5-th percentile	-62.4366
Q1	-14.179
median	12.496
Q3	49.196
95-th percentile	220.7852
Maximum	61584.348
Range	61684.348
Interquartile range (IQR)	63.375

Descriptive statistics

Standard deviation	622.8505
Coefficient of variation (CV)	10.873949
Kurtosis	5628.7641
Mean	57.279147
Median Absolute Deviation (MAD)	30.634
Skewness	64.956752
Sum	1052160.7
Variance	387942.75
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	31	0.1%
18.205	5	< 0.1%
-100	5	< 0.1%
2.491	4	< 0.1%
5.765	4	< 0.1%
12.607	3	< 0.1%
21.379	3	< 0.1%
-5.905	3	< 0.1%
-32.812	3	< 0.1%
19.62	3	< 0.1%
Other values (17354)	18305	63.2%
(Missing)	10584	36.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-100	5	< 0.1%
-99.999	1	< 0.1%
-99.976	1	< 0.1%
-99.888	1	< 0.1%
-99.842	1	< 0.1%
-99.81	1	< 0.1%
-99.088	1	< 0.1%
-98.825	1	< 0.1%
-98.81	1	< 0.1%
-98.62	1	< 0.1%

Value	Count	Frequency (%)
61584.348	1	< 0.1%
26917.081	1	< 0.1%
26044.747	1	< 0.1%
19328.696	1	< 0.1%
13753.536	1	< 0.1%
12836.159	1	< 0.1%
12066.569	1	< 0.1%
11154.725	1	< 0.1%
8152.02	1	< 0.1%
8138.907	1	< 0.1%

COMMENT
Categorical

HIGH CARDINALITY MISSING

Distinct	1413
Distinct (%)	65.0%
Missing	26778
Missing (%)	92.5%
Memory size	226.3 KiB

*Excl. portion of bonus paid in restricted stock.	109
*May contain preliminary information.	56
*Excl. 50% of bonus paid in stock options.	31
*Excludes portion of bonus paid in restricted stock.	26
*Compensation also listed under USX-U.S. Steel.	23
Other values (1408)	1930

Length

Max length	235
Median length	181
Mean length	50.11954
Min length	12

Characters and Unicode

Total characters	109010
Distinct characters	77
Distinct categories	11 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1223 ?
Unique (%)	56.2%

Sample

1st row	*1994 bonus has not been determined.
2nd row	*1996 LTIP has not yet been determined.
3rd row	*Includes $638,600 in consulting/severance payments and $73,684 in accrued vacation pay.
4th row	Includes $1,156,981 in consulting/severance payments and $60,000 in accrued vacation pay.
5th row	*Incl one additional pay period.

Common Values

Value	Count	Frequency (%)
*Excl. portion of bonus paid in restricted stock.	109	0.4%
*May contain preliminary information.	56	0.2%
*Excl. 50% of bonus paid in stock options.	31	0.1%
*Excludes portion of bonus paid in restricted stock.	26	0.1%
*Compensation also listed under USX-U.S. Steel.	23	0.1%
*Excl. portion of bonus pd in restricted stock.	21	0.1%
*Compensation also listed under Newmont Gold Co.	14	< 0.1%
*Incl one additional pay period.	14	< 0.1%
*Elected to forego salary & bonus for stock opt. grants.	13	< 0.1%
*Includes portion of bonus paid in options.	13	< 0.1%
Other values (1403)	1855	6.4%
(Missing)	26778	92.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
in	887	5.4%
bonus	788	4.8%
incl	710	4.3%
of	648	3.9%
paid	514	3.1%
stock	436	2.6%
excl	434	2.6%
includes	347	2.1%
restricted	277	1.7%
to	276	1.7%
Other values (2036)	11160	67.7%

Most occurring characters

Value	Count	Frequency (%)
	14337	13.2%
n	7681	7.0%
e	7166	6.6%
o	6662	6.1%
i	5552	5.1%
t	5404	5.0%
s	5172	4.7%
r	4651	4.3%
a	4459	4.1%
c	4014	3.7%
Other values (67)	43912	40.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	72303	66.3%
Space Separator	14337	13.2%
Decimal Number	8864	8.1%
Other Punctuation	8070	7.4%
Uppercase Letter	3825	3.5%
Currency Symbol	1248	1.1%
Dash Punctuation	245	0.2%
Close Punctuation	50	< 0.1%
Open Punctuation	50	< 0.1%
Final Punctuation	13	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
n	7681	10.6%
e	7166	9.9%
o	6662	9.2%
i	5552	7.7%
t	5404	7.5%
s	5172	7.2%
r	4651	6.4%
a	4459	6.2%
c	4014	5.6%
l	3478	4.8%
Other values (16)	18064	25.0%

Uppercase Letter

Value	Count	Frequency (%)
I	1169	30.6%
E	617	16.1%
C	330	8.6%
S	246	6.4%
M	216	5.6%
P	166	4.3%
T	155	4.1%
A	134	3.5%
R	123	3.2%
O	106	2.8%
Other values (15)	563	14.7%

Decimal Number

Value	Count	Frequency (%)
0	2592	29.2%
1	1031	11.6%
5	848	9.6%
2	827	9.3%
9	731	8.2%
3	688	7.8%
4	595	6.7%
8	523	5.9%
7	518	5.8%
6	511	5.8%

Other Punctuation

Value	Count	Frequency (%)
.	3845	47.6%
*	2245	27.8%
,	1422	17.6%
/	255	3.2%
&	147	1.8%
'	76	0.9%
%	68	0.8%
;	12	0.1%

Math Symbol

Value	Count	Frequency (%)
=	4	80.0%
+	1	20.0%

Space Separator

Value	Count	Frequency (%)
	14337	100.0%

Currency Symbol

Value	Count	Frequency (%)
$	1248	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	245	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	50	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	50	100.0%

Final Punctuation

Value	Count	Frequency (%)
’	13	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	76128	69.8%
Common	32882	30.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
n	7681	10.1%
e	7166	9.4%
o	6662	8.8%
i	5552	7.3%
t	5404	7.1%
s	5172	6.8%
r	4651	6.1%
a	4459	5.9%
c	4014	5.3%
l	3478	4.6%
Other values (41)	21889	28.8%

Common

Value	Count	Frequency (%)
	14337	43.6%
.	3845	11.7%
0	2592	7.9%
*	2245	6.8%
,	1422	4.3%
$	1248	3.8%
1	1031	3.1%
5	848	2.6%
2	827	2.5%
9	731	2.2%
Other values (16)	3756	11.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	108997	> 99.9%
Punctuation	13	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	14337	13.2%
n	7681	7.0%
e	7166	6.6%
o	6662	6.1%
i	5552	5.1%
t	5404	5.0%
s	5172	4.7%
r	4651	4.3%
a	4459	4.1%
c	4014	3.7%
Other values (66)	43899	40.3%

Punctuation

Value	Count	Frequency (%)
’	13	100.0%

GVKEY
Real number (ℝ)

Distinct	386
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	17473.837

Minimum	1045
Maximum	260774
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	226.3 KiB

Quantile statistics

Minimum	1045
5-th percentile	1678
Q1	4510
median	8099
Q3	14418
95-th percentile	65609
Maximum	260774
Range	259729
Interquartile range (IQR)	9908

Descriptive statistics

Standard deviation	28499.711
Coefficient of variation (CV)	1.6309934
Kurtosis	13.215268
Mean	17473.837
Median Absolute Deviation (MAD)	4042
Skewness	3.4688056
Sum	5.0591999 × 10⁸
Variance	8.1223355 × 10⁸
Monotonicity	Increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
8264	138	0.5%
9846	124	0.4%
13988	118	0.4%
8549	112	0.4%
4839	111	0.4%
3439	109	0.4%
7343	108	0.4%
1487	107	0.4%
8539	106	0.4%
11506	106	0.4%
Other values (376)	27814	96.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1045	91	0.3%
1075	89	0.3%
1078	90	0.3%
1161	95	0.3%
1209	97	0.3%
1230	89	0.3%
1300	89	0.3%
1327	58	0.2%
1380	84	0.3%
1440	89	0.3%

Value	Count	Frequency (%)
260774	20	0.1%
165993	15	0.1%
164708	15	0.1%
160329	14	< 0.1%
155394	22	0.1%
150937	26	0.1%
149337	15	0.1%
149070	22	0.1%
145977	25	0.1%
145701	33	0.1%

EXECID
Real number (ℝ)

Distinct	5084
Distinct (%)	17.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12805.586

Minimum	3
Maximum	34976
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	226.3 KiB

Quantile statistics

Minimum	3
5-th percentile	717
Q1	3661
median	12604
Q3	20823
95-th percentile	27633
Maximum	34976
Range	34973
Interquartile range (IQR)	17162

Descriptive statistics

Standard deviation	9132.5122
Coefficient of variation (CV)	0.71316629
Kurtosis	-1.2405848
Mean	12805.586
Median Absolute Deviation (MAD)	8600
Skewness	0.20307487
Sum	3.7076013 × 10⁸
Variance	83402779
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3765	16	0.1%
5669	15	0.1%
116	15	0.1%
3434	14	< 0.1%
4228	14	< 0.1%
1030	14	< 0.1%
5820	14	< 0.1%
125	14	< 0.1%
9752	14	< 0.1%
9753	14	< 0.1%
Other values (5074)	28809	99.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3	7	< 0.1%
7	10	< 0.1%
8	12	< 0.1%
10	6	< 0.1%
13	14	< 0.1%
15	10	< 0.1%
26	11	< 0.1%
28	3	< 0.1%
36	4	< 0.1%
39	2	< 0.1%

Value	Count	Frequency (%)
34976	2	< 0.1%
34974	1	< 0.1%
34965	2	< 0.1%
34964	2	< 0.1%
34963	5	< 0.1%
34897	3	< 0.1%
34896	4	< 0.1%
34895	4	< 0.1%
34406	5	< 0.1%
34404	2	< 0.1%

YEAR
Real number (ℝ)

Distinct	14
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1999.008

Minimum	1992
Maximum	2005
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	226.3 KiB

Quantile statistics

Minimum	1992
5-th percentile	1993
Q1	1996
median	1999
Q3	2002
95-th percentile	2005
Maximum	2005
Range	13
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.8733942
Coefficient of variation (CV)	0.0019376582
Kurtosis	-1.1161784
Mean	1999.008
Median Absolute Deviation (MAD)	3
Skewness	-0.16344235
Sum	57877279
Variance	15.003183
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=14)

Value	Count	Frequency (%)
2003	2458	8.5%
2002	2410	8.3%
2001	2344	8.1%
2004	2315	8.0%
2000	2304	8.0%
1999	2275	7.9%
1998	2188	7.6%
2005	2075	7.2%
1997	2027	7.0%
1996	1900	6.6%
Other values (4)	6657	23.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1992	1399	4.8%
1993	1653	5.7%
1994	1774	6.1%
1995	1831	6.3%
1996	1900	6.6%
1997	2027	7.0%
1998	2188	7.6%
1999	2275	7.9%
2000	2304	8.0%
2001	2344	8.1%

Value	Count	Frequency (%)
2005	2075	7.2%
2004	2315	8.0%
2003	2458	8.5%
2002	2410	8.3%
2001	2344	8.1%
2000	2304	8.0%
1999	2275	7.9%
1998	2188	7.6%
1997	2027	7.0%
1996	1900	6.6%

BECAMECEO
Categorical

HIGH CARDINALITY MISSING

Distinct	559
Distinct (%)	7.0%
Missing	20979
Missing (%)	72.5%
Memory size	226.3 KiB

2000-01-01	197
2001-01-01	143
1998-01-01	140
1994-01-01	113
1990-01-01	109
Other values (554)	7272

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	79740
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	12 ?
Unique (%)	0.2%

Sample

1st row	1985-03-01
2nd row	1998-05-20
3rd row	1985-03-01
4th row	1998-05-20
5th row	1985-03-01

Common Values

Value	Count	Frequency (%)
2000-01-01	197	0.7%
2001-01-01	143	0.5%
1998-01-01	140	0.5%
1994-01-01	113	0.4%
1990-01-01	109	0.4%
1993-01-01	101	0.3%
1999-01-01	98	0.3%
1997-01-01	91	0.3%
2001-02-01	82	0.3%
2002-01-01	80	0.3%
Other values (549)	6820	23.6%
(Missing)	20979	72.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2000-01-01	197	2.5%
2001-01-01	143	1.8%
1998-01-01	140	1.8%
1994-01-01	113	1.4%
1990-01-01	109	1.4%
1993-01-01	101	1.3%
1999-01-01	98	1.2%
1997-01-01	91	1.1%
2001-02-01	82	1.0%
2002-01-01	80	1.0%
Other values (549)	6820	85.5%

Most occurring characters

Value	Count	Frequency (%)
0	21186	26.6%
1	17139	21.5%
-	15948	20.0%
9	9019	11.3%
2	5809	7.3%
8	2266	2.8%
7	2048	2.6%
5	1826	2.3%
4	1556	2.0%
3	1535	1.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	63792	80.0%
Dash Punctuation	15948	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	21186	33.2%
1	17139	26.9%
9	9019	14.1%
2	5809	9.1%
8	2266	3.6%
7	2048	3.2%
5	1826	2.9%
4	1556	2.4%
3	1535	2.4%
6	1408	2.2%

Dash Punctuation

Value	Count	Frequency (%)
-	15948	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	79740	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	21186	26.6%
1	17139	21.5%
-	15948	20.0%
9	9019	11.3%
2	5809	7.3%
8	2266	2.8%
7	2048	2.6%
5	1826	2.3%
4	1556	2.0%
3	1535	1.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	79740	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	21186	26.6%
1	17139	21.5%
-	15948	20.0%
9	9019	11.3%
2	5809	7.3%
8	2266	2.8%
7	2048	2.6%
5	1826	2.3%
4	1556	2.0%
3	1535	1.9%

JOINED_CO
Categorical

HIGH CARDINALITY MISSING

Distinct	564
Distinct (%)	5.9%
Missing	19336
Missing (%)	66.8%
Memory size	226.3 KiB

1979-01-01	195
1976-01-01	162
1984-01-01	147
1975-01-01	139
1963-01-01	139
Other values (559)	8835

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	96170
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	44 ?
Unique (%)	0.5%

Sample

1st row	1973-04-01
2nd row	1973-04-01
3rd row	1973-04-01
4th row	1973-04-01
5th row	1973-04-01

Common Values

Value	Count	Frequency (%)
1979-01-01	195	0.7%
1976-01-01	162	0.6%
1984-01-01	147	0.5%
1975-01-01	139	0.5%
1963-01-01	139	0.5%
1982-01-01	139	0.5%
1969-01-01	137	0.5%
1966-01-01	135	0.5%
1983-01-01	132	0.5%
1971-01-01	131	0.5%
Other values (554)	8161	28.2%
(Missing)	19336	66.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
1979-01-01	195	2.0%
1976-01-01	162	1.7%
1984-01-01	147	1.5%
1975-01-01	139	1.4%
1963-01-01	139	1.4%
1982-01-01	139	1.4%
1969-01-01	137	1.4%
1966-01-01	135	1.4%
1983-01-01	132	1.4%
1971-01-01	131	1.4%
Other values (554)	8161	84.9%

Most occurring characters

Value	Count	Frequency (%)
1	24555	25.5%
0	21635	22.5%
-	19234	20.0%
9	13214	13.7%
2	3614	3.8%
8	3119	3.2%
6	2830	2.9%
7	2789	2.9%
5	1822	1.9%
4	1689	1.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	76936	80.0%
Dash Punctuation	19234	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	24555	31.9%
0	21635	28.1%
9	13214	17.2%
2	3614	4.7%
8	3119	4.1%
6	2830	3.7%
7	2789	3.6%
5	1822	2.4%
4	1689	2.2%
3	1669	2.2%

Dash Punctuation

Value	Count	Frequency (%)
-	19234	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	96170	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	24555	25.5%
0	21635	22.5%
-	19234	20.0%
9	13214	13.7%
2	3614	3.8%
8	3119	3.2%
6	2830	2.9%
7	2789	2.9%
5	1822	1.9%
4	1689	1.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	96170	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	24555	25.5%
0	21635	22.5%
-	19234	20.0%
9	13214	13.7%
2	3614	3.8%
8	3119	3.2%
6	2830	2.9%
7	2789	2.9%
5	1822	1.9%
4	1689	1.8%

REJOIN
Categorical

Distinct	22
Distinct (%)	13.3%
Missing	28787
Missing (%)	99.4%
Memory size	226.3 KiB

1991-01-01	15
1994-01-01	14
1995-11-01	11
1976-01-01	11
1995-02-01	11
Other values (17)	104

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	1660
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	0.6%

Sample

1st row	2001-07-03
2nd row	2001-07-03
3rd row	2001-07-03
4th row	2001-07-03
5th row	2001-07-03

Common Values

Value	Count	Frequency (%)
1991-01-01	15	0.1%
1994-01-01	14	< 0.1%
1995-11-01	11	< 0.1%
1976-01-01	11	< 0.1%
1995-02-01	11	< 0.1%
2001-07-03	11	< 0.1%
1983-01-01	11	< 0.1%
2003-12-01	9	< 0.1%
2002-04-01	9	< 0.1%
2001-09-01	9	< 0.1%
Other values (12)	55	0.2%
(Missing)	28787	99.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
1991-01-01	15	9.0%
1994-01-01	14	8.4%
1995-11-01	11	6.6%
1976-01-01	11	6.6%
1995-02-01	11	6.6%
2001-07-03	11	6.6%
1983-01-01	11	6.6%
2003-12-01	9	5.4%
2002-04-01	9	5.4%
2001-09-01	9	5.4%
Other values (12)	55	33.1%

Most occurring characters

Value	Count	Frequency (%)
0	437	26.3%
1	397	23.9%
-	332	20.0%
9	177	10.7%
2	136	8.2%
3	47	2.8%
5	39	2.3%
8	31	1.9%
4	23	1.4%
7	23	1.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1328	80.0%
Dash Punctuation	332	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	437	32.9%
1	397	29.9%
9	177	13.3%
2	136	10.2%
3	47	3.5%
5	39	2.9%
8	31	2.3%
4	23	1.7%
7	23	1.7%
6	18	1.4%

Dash Punctuation

Value	Count	Frequency (%)
-	332	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1660	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	437	26.3%
1	397	23.9%
-	332	20.0%
9	177	10.7%
2	136	8.2%
3	47	2.8%
5	39	2.3%
8	31	1.9%
4	23	1.4%
7	23	1.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1660	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	437	26.3%
1	397	23.9%
-	332	20.0%
9	177	10.7%
2	136	8.2%
3	47	2.8%
5	39	2.3%
8	31	1.9%
4	23	1.4%
7	23	1.4%

LEFTOFC
Categorical

HIGH CARDINALITY MISSING

Distinct	659
Distinct (%)	9.0%
Missing	21623
Missing (%)	74.7%
Memory size	226.3 KiB

2005-12-31	98
2005-07-01	66
2007-01-01	63
2007-07-01	59
2008-01-01	58
Other values (654)	6986

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	73300
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	10 ?
Unique (%)	0.1%

Sample

1st row	1998-05-20
2nd row	2003-04-24
3rd row	1998-05-20
4th row	2003-04-24
5th row	1998-05-20

Common Values

Value	Count	Frequency (%)
2005-12-31	98	0.3%
2005-07-01	66	0.2%
2007-01-01	63	0.2%
2007-07-01	59	0.2%
2008-01-01	58	0.2%
2013-01-01	51	0.2%
2004-07-01	48	0.2%
1998-12-31	47	0.2%
2000-12-31	46	0.2%
2011-01-01	45	0.2%
Other values (649)	6749	23.3%
(Missing)	21623	74.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2005-12-31	98	1.3%
2005-07-01	66	0.9%
2007-01-01	63	0.9%
2007-07-01	59	0.8%
2008-01-01	58	0.8%
2013-01-01	51	0.7%
2004-07-01	48	0.7%
1998-12-31	47	0.6%
2000-12-31	46	0.6%
2011-01-01	45	0.6%
Other values (649)	6749	92.1%

Most occurring characters

Value	Count	Frequency (%)
0	20742	28.3%
-	14660	20.0%
1	12873	17.6%
2	9966	13.6%
9	3803	5.2%
3	3125	4.3%
5	1933	2.6%
4	1785	2.4%
7	1732	2.4%
6	1368	1.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	58640	80.0%
Dash Punctuation	14660	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	20742	35.4%
1	12873	22.0%
2	9966	17.0%
9	3803	6.5%
3	3125	5.3%
5	1933	3.3%
4	1785	3.0%
7	1732	3.0%
6	1368	2.3%
8	1313	2.2%

Dash Punctuation

Value	Count	Frequency (%)
-	14660	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	73300	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	20742	28.3%
-	14660	20.0%
1	12873	17.6%
2	9966	13.6%
9	3803	5.2%
3	3125	4.3%
5	1933	2.6%
4	1785	2.4%
7	1732	2.4%
6	1368	1.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	73300	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	20742	28.3%
-	14660	20.0%
1	12873	17.6%
2	9966	13.6%
9	3803	5.2%
3	3125	4.3%
5	1933	2.6%
4	1785	2.4%
7	1732	2.4%
6	1368	1.9%

LEFTCO
Categorical

HIGH CARDINALITY MISSING

Distinct	780
Distinct (%)	8.8%
Missing	20082
Missing (%)	69.4%
Memory size	226.3 KiB

2005-12-31	165
2007-12-31	147
2004-12-31	130
2008-12-31	126
1999-12-31	112
Other values (775)	8191

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	88710
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	17 ?
Unique (%)	0.2%

Sample

1st row	1998-12-31
2nd row	2002-04-01
3rd row	2003-04-24
4th row	2002-09-17
5th row	1995-01-15

Common Values

Value	Count	Frequency (%)
2005-12-31	165	0.6%
2007-12-31	147	0.5%
2004-12-31	130	0.4%
2008-12-31	126	0.4%
1999-12-31	112	0.4%
2002-12-31	97	0.3%
2003-12-31	93	0.3%
1998-12-31	83	0.3%
2006-12-31	83	0.3%
2002-01-01	61	0.2%
Other values (770)	7774	26.9%
(Missing)	20082	69.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2005-12-31	165	1.9%
2007-12-31	147	1.7%
2004-12-31	130	1.5%
2008-12-31	126	1.4%
1999-12-31	112	1.3%
2002-12-31	97	1.1%
2003-12-31	93	1.0%
1998-12-31	83	0.9%
2006-12-31	83	0.9%
2002-01-01	61	0.7%
Other values (770)	7774	87.6%

Most occurring characters

Value	Count	Frequency (%)
0	25332	28.6%
-	17742	20.0%
1	13635	15.4%
2	11084	12.5%
9	5938	6.7%
3	4870	5.5%
7	2226	2.5%
5	2057	2.3%
8	2028	2.3%
6	1924	2.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	70968	80.0%
Dash Punctuation	17742	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	25332	35.7%
1	13635	19.2%
2	11084	15.6%
9	5938	8.4%
3	4870	6.9%
7	2226	3.1%
5	2057	2.9%
8	2028	2.9%
6	1924	2.7%
4	1874	2.6%

Dash Punctuation

Value	Count	Frequency (%)
-	17742	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	88710	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	25332	28.6%
-	17742	20.0%
1	13635	15.4%
2	11084	12.5%
9	5938	6.7%
3	4870	5.5%
7	2226	2.5%
5	2057	2.3%
8	2028	2.3%
6	1924	2.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	88710	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	25332	28.6%
-	17742	20.0%
1	13635	15.4%
2	11084	12.5%
9	5938	6.7%
3	4870	5.5%
7	2226	2.5%
5	2057	2.3%
8	2028	2.3%
6	1924	2.2%

RELEFT
Categorical

Distinct	9
Distinct (%)	12.9%
Missing	28883
Missing (%)	99.8%
Memory size	226.3 KiB

2006-10-18	12
2002-07-01	11
2006-12-31	11
2002-04-25	11
2005-04-01	9
Other values (4)	16

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	700
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2002-07-01
2nd row	2002-07-01
3rd row	2002-07-01
4th row	2002-07-01
5th row	2002-07-01

Common Values

Value	Count	Frequency (%)
2006-10-18	12	< 0.1%
2002-07-01	11	< 0.1%
2006-12-31	11	< 0.1%
2002-04-25	11	< 0.1%
2005-04-01	9	< 0.1%
2005-02-01	6	< 0.1%
1997-07-01	6	< 0.1%
1994-12-31	2	< 0.1%
1996-11-20	2	< 0.1%
(Missing)	28883	99.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2006-10-18	12	17.1%
2002-07-01	11	15.7%
2006-12-31	11	15.7%
2002-04-25	11	15.7%
2005-04-01	9	12.9%
2005-02-01	6	8.6%
1997-07-01	6	8.6%
1994-12-31	2	2.9%
1996-11-20	2	2.9%

Most occurring characters

Value	Count	Frequency (%)
0	209	29.9%
-	140	20.0%
2	114	16.3%
1	96	13.7%
5	26	3.7%
6	25	3.6%
7	23	3.3%
4	22	3.1%
9	20	2.9%
3	13	1.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	560	80.0%
Dash Punctuation	140	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	209	37.3%
2	114	20.4%
1	96	17.1%
5	26	4.6%
6	25	4.5%
7	23	4.1%
4	22	3.9%
9	20	3.6%
3	13	2.3%
8	12	2.1%

Dash Punctuation

Value	Count	Frequency (%)
-	140	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	700	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	209	29.9%
-	140	20.0%
2	114	16.3%
1	96	13.7%
5	26	3.7%
6	25	3.6%
7	23	3.3%
4	22	3.1%
9	20	2.9%
3	13	1.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	700	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	209	29.9%
-	140	20.0%
2	114	16.3%
1	96	13.7%
5	26	3.7%
6	25	3.6%
7	23	3.3%
4	22	3.1%
9	20	2.9%
3	13	1.9%

PCEO
Categorical

CONSTANT MISSING

Distinct	1
Distinct (%)	0.1%
Missing	28285
Missing (%)	97.7%
Memory size	226.3 KiB

CEO	668

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	2004
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	CEO
2nd row	CEO
3rd row	CEO
4th row	CEO
5th row	CEO

Common Values

Value	Count	Frequency (%)
CEO	668	2.3%
(Missing)	28285	97.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
ceo	668	100.0%

Most occurring characters

Value	Count	Frequency (%)
C	668	33.3%
E	668	33.3%
O	668	33.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	2004	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
C	668	33.3%
E	668	33.3%
O	668	33.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2004	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
C	668	33.3%
E	668	33.3%
O	668	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2004	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
C	668	33.3%
E	668	33.3%
O	668	33.3%

PCFO
Categorical

CONSTANT MISSING

Distinct	1
Distinct (%)	1.1%
Missing	28858
Missing (%)	99.7%
Memory size	226.3 KiB

CFO	95

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	285
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	CFO
2nd row	CFO
3rd row	CFO
4th row	CFO
5th row	CFO

Common Values

Value	Count	Frequency (%)
CFO	95	0.3%
(Missing)	28858	99.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
cfo	95	100.0%

Most occurring characters

Value	Count	Frequency (%)
C	95	33.3%
F	95	33.3%
O	95	33.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	285	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
C	95	33.3%
F	95	33.3%
O	95	33.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	285	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
C	95	33.3%
F	95	33.3%
O	95	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	285	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
C	95	33.3%
F	95	33.3%
O	95	33.3%

TITLE
Categorical

Distinct	2655
Distinct (%)	9.2%
Missing	5
Missing (%)	< 0.1%
Memory size	226.3 KiB

chairman & CEO	1093
chairman	965
executive vp	891
vice chairman	681
Executive Chairman	585
Other values (2650)	24733

Length

Max length	231
Median length	175
Mean length	29.985664
Min length	3

Characters and Unicode

Total characters	868025
Distinct characters	64
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	125 ?
Unique (%)	0.4%

Sample

1st row	chmn., pres. & CEO
2nd row	vice chairman
3rd row	chairman & CEO
4th row	executive vp; executive vp-marketing & planning-American
5th row	sr. v-p

Common Values

Value	Count	Frequency (%)
chairman & CEO	1093	3.8%
chairman	965	3.3%
executive vp	891	3.1%
vice chairman	681	2.4%
Executive Chairman	585	2.0%
exec. v-p	569	2.0%
senior vp	497	1.7%
sr. v-p	378	1.3%
chmn. & CEO	377	1.3%
president & chief operating officer	349	1.2%
Other values (2645)	22563	77.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
	11818	9.5%
executive	8796	7.1%
chairman	8224	6.6%
president	5684	4.6%
chief	5639	4.5%
officer	5562	4.5%
vp	5002	4.0%
of	4367	3.5%
and	4237	3.4%
vice	3989	3.2%
Other values (2066)	61004	49.1%

Most occurring characters

Value	Count	Frequency (%)
e	99729	11.5%
	95491	11.0%
i	69579	8.0%
r	58312	6.7%
n	52870	6.1%
c	45866	5.3%
a	45528	5.2%
t	37407	4.3%
o	35865	4.1%
s	29418	3.4%
Other values (54)	297960	34.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	668144	77.0%
Space Separator	95491	11.0%
Uppercase Letter	64868	7.5%
Other Punctuation	26342	3.0%
Dash Punctuation	13081	1.5%
Close Punctuation	40	< 0.1%
Open Punctuation	40	< 0.1%
Decimal Number	19	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	99729	14.9%
i	69579	10.4%
r	58312	8.7%
n	52870	7.9%
c	45866	6.9%
a	45528	6.8%
t	37407	5.6%
o	35865	5.4%
s	29418	4.4%
f	27894	4.2%
Other values (16)	165676	24.8%

Uppercase Letter

Value	Count	Frequency (%)
C	16901	26.1%
E	10838	16.7%
O	9424	14.5%
P	5460	8.4%
V	2976	4.6%
S	2825	4.4%
F	2208	3.4%
A	2122	3.3%
D	1872	2.9%
M	1860	2.9%
Other values (16)	8382	12.9%

Other Punctuation

Value	Count	Frequency (%)
&	11989	45.5%
.	7912	30.0%
,	5008	19.0%
;	1291	4.9%
/	79	0.3%
'	63	0.2%

Decimal Number

Value	Count	Frequency (%)
2	13	68.4%
4	6	31.6%

Space Separator

Value	Count	Frequency (%)
	95491	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	13081	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	40	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	40	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	733012	84.4%
Common	135013	15.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	99729	13.6%
i	69579	9.5%
r	58312	8.0%
n	52870	7.2%
c	45866	6.3%
a	45528	6.2%
t	37407	5.1%
o	35865	4.9%
s	29418	4.0%
f	27894	3.8%
Other values (42)	230544	31.5%

Common

Value	Count	Frequency (%)
	95491	70.7%
-	13081	9.7%
&	11989	8.9%
.	7912	5.9%
,	5008	3.7%
;	1291	1.0%
/	79	0.1%
'	63	< 0.1%
)	40	< 0.1%
(	40	< 0.1%
Other values (2)	19	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	868025	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	99729	11.5%
	95491	11.0%
i	69579	8.0%
r	58312	6.7%
n	52870	6.1%
c	45866	5.3%
a	45528	5.2%
t	37407	4.3%
o	35865	4.1%
s	29418	3.4%
Other values (54)	297960	34.3%

REASON
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	20141
Missing (%)	69.6%
Memory size	226.3 KiB

RETIRED	5619
RESIGNED	2204
UNKNOWN	856
DECEASED	133

Length

Max length	8
Median length	7
Mean length	7.2652065
Min length	7

Characters and Unicode

Total characters	64021
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	RETIRED
2nd row	RETIRED
3rd row	RESIGNED
4th row	RETIRED
5th row	RETIRED

Common Values

Value	Count	Frequency (%)
RETIRED	5619	19.4%
RESIGNED	2204	7.6%
UNKNOWN	856	3.0%
DECEASED	133	0.5%
(Missing)	20141	69.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
retired	5619	63.8%
resigned	2204	25.0%
unknown	856	9.7%
deceased	133	1.5%

Most occurring characters

Value	Count	Frequency (%)
E	16045	25.1%
R	13442	21.0%
D	8089	12.6%
I	7823	12.2%
T	5619	8.8%
N	4772	7.5%
S	2337	3.7%
G	2204	3.4%
U	856	1.3%
K	856	1.3%
Other values (4)	1978	3.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	64021	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	16045	25.1%
R	13442	21.0%
D	8089	12.6%
I	7823	12.2%
T	5619	8.8%
N	4772	7.5%
S	2337	3.7%
G	2204	3.4%
U	856	1.3%
K	856	1.3%
Other values (4)	1978	3.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	64021	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	16045	25.1%
R	13442	21.0%
D	8089	12.6%
I	7823	12.2%
T	5619	8.8%
N	4772	7.5%
S	2337	3.7%
G	2204	3.4%
U	856	1.3%
K	856	1.3%
Other values (4)	1978	3.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	64021	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	16045	25.1%
R	13442	21.0%
D	8089	12.6%
I	7823	12.2%
T	5619	8.8%
N	4772	7.5%
S	2337	3.7%
G	2204	3.4%
U	856	1.3%
K	856	1.3%
Other values (4)	1978	3.1%

EXEC_LNAME
Categorical

Distinct	3976
Distinct (%)	13.7%
Missing	6
Missing (%)	< 0.1%
Memory size	226.3 KiB

Smith	208
Johnson	202
Miller	124
Lewis	88
Campbell	87
Other values (3971)	28238

Length

Max length	20
Median length	18
Mean length	7.244274
Min length	2

Characters and Unicode

Total characters	209700
Distinct characters	59
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	152 ?
Unique (%)	0.5%

Sample

1st row	Crandall
2nd row	Baker
3rd row	Carty
4th row	Gunn
5th row	Hopper

Common Values

Value	Count	Frequency (%)
Smith	208	0.7%
Johnson	202	0.7%
Miller	124	0.4%
Lewis	88	0.3%
Campbell	87	0.3%
Williams	86	0.3%
Thompson	75	0.3%
Kelly	71	0.2%
Ryan	70	0.2%
Sullivan	67	0.2%
Other values (3966)	27869	96.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
jr	1640	5.0%
iii	412	1.3%
ph.d	256	0.8%
smith	247	0.8%
johnson	221	0.7%
cpa	207	0.6%
miller	137	0.4%
ii	114	0.3%
m.b.a	105	0.3%
lewis	97	0.3%
Other values (3839)	29357	89.5%

Most occurring characters

Value	Count	Frequency (%)
e	20427	9.7%
r	16600	7.9%
a	15154	7.2%
n	15094	7.2%
o	12613	6.0%
l	12063	5.8%
i	11171	5.3%
s	8595	4.1%
t	7788	3.7%
h	5903	2.8%
Other values (49)	84292	40.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	161847	77.2%
Uppercase Letter	36643	17.5%
Other Punctuation	7274	3.5%
Space Separator	3846	1.8%
Dash Punctuation	74	< 0.1%
Open Punctuation	11	< 0.1%
Close Punctuation	5	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	20427	12.6%
r	16600	10.3%
a	15154	9.4%
n	15094	9.3%
o	12613	7.8%
l	12063	7.5%
i	11171	6.9%
s	8595	5.3%
t	7788	4.8%
h	5903	3.6%
Other values (16)	36439	22.5%

Uppercase Letter

Value	Count	Frequency (%)
S	3315	9.0%
B	3101	8.5%
M	3066	8.4%
C	2747	7.5%
J	2554	7.0%
H	1926	5.3%
D	1915	5.2%
W	1831	5.0%
P	1802	4.9%
G	1767	4.8%
Other values (16)	12619	34.4%

Other Punctuation

Value	Count	Frequency (%)
.	3602	49.5%
,	3398	46.7%
'	274	3.8%

Space Separator

Value	Count	Frequency (%)
	3846	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	74	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	11	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	5	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	198490	94.7%
Common	11210	5.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	20427	10.3%
r	16600	8.4%
a	15154	7.6%
n	15094	7.6%
o	12613	6.4%
l	12063	6.1%
i	11171	5.6%
s	8595	4.3%
t	7788	3.9%
h	5903	3.0%
Other values (42)	73082	36.8%

Common

Value	Count	Frequency (%)
	3846	34.3%
.	3602	32.1%
,	3398	30.3%
'	274	2.4%
-	74	0.7%
(	11	0.1%
)	5	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	209700	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	20427	9.7%
r	16600	7.9%
a	15154	7.2%
n	15094	7.2%
o	12613	6.0%
l	12063	5.8%
i	11171	5.3%
s	8595	4.1%
t	7788	3.7%
h	5903	2.8%
Other values (49)	84292	40.2%

EXEC_FNAME
Categorical

Distinct	811
Distinct (%)	2.8%
Missing	6
Missing (%)	< 0.1%
Memory size	226.3 KiB

John	1856
Robert	1439
James	1336
William	1120
David	1079
Other values (806)	22117

Length

Max length	16
Median length	14
Mean length	5.4888589
Min length	2

Characters and Unicode

Total characters	158886
Distinct characters	55
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	25 ?
Unique (%)	0.1%

Sample

1st row	Robert
2nd row	Robert
3rd row	Donald
4th row	Michael
5th row	Max

Common Values

Value	Count	Frequency (%)
John	1856	6.4%
Robert	1439	5.0%
James	1336	4.6%
William	1120	3.9%
David	1079	3.7%
Michael	956	3.3%
Richard	937	3.2%
Thomas	793	2.7%
Charles	500	1.7%
Joseph	403	1.4%
Other values (801)	18528	64.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
john	1859	6.4%
robert	1444	5.0%
james	1336	4.6%
william	1134	3.9%
david	1084	3.7%
michael	964	3.3%
richard	937	3.2%
thomas	793	2.7%
charles	503	1.7%
joseph	403	1.4%
Other values (788)	18600	64.0%

Most occurring characters

Value	Count	Frequency (%)
e	15956	10.0%
a	15893	10.0%
r	12689	8.0%
n	9941	6.3%
i	9610	6.0%
o	9197	5.8%
l	8921	5.6%
h	7991	5.0%
d	5426	3.4%
t	5248	3.3%
Other values (45)	58014	36.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	127596	80.3%
Uppercase Letter	29151	18.3%
Other Punctuation	1948	1.2%
Space Separator	110	0.1%
Dash Punctuation	81	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	15956	12.5%
a	15893	12.5%
r	12689	9.9%
n	9941	7.8%
i	9610	7.5%
o	9197	7.2%
l	8921	7.0%
h	7991	6.3%
d	5426	4.3%
t	5248	4.1%
Other values (16)	26724	20.9%

Uppercase Letter

Value	Count	Frequency (%)
J	5048	17.3%
R	3651	12.5%
D	2760	9.5%
M	2151	7.4%
W	1796	6.2%
G	1460	5.0%
S	1406	4.8%
C	1321	4.5%
T	1273	4.4%
P	1253	4.3%
Other values (16)	7032	24.1%

Other Punctuation

Value	Count	Frequency (%)
.	1948	100.0%

Space Separator

Value	Count	Frequency (%)
	110	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	81	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	156747	98.7%
Common	2139	1.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	15956	10.2%
a	15893	10.1%
r	12689	8.1%
n	9941	6.3%
i	9610	6.1%
o	9197	5.9%
l	8921	5.7%
h	7991	5.1%
d	5426	3.5%
t	5248	3.3%
Other values (42)	55875	35.6%

Common

Value	Count	Frequency (%)
.	1948	91.1%
	110	5.1%
-	81	3.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	158886	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	15956	10.0%
a	15893	10.0%
r	12689	8.0%
n	9941	6.3%
i	9610	6.0%
o	9197	5.8%
l	8921	5.6%
h	7991	5.0%
d	5426	3.4%
t	5248	3.3%
Other values (45)	58014	36.5%

GENDER
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	226.3 KiB

MALE	27817
FEMALE	1136

Length

Max length	6
Median length	4
Mean length	4.078472
Min length	4

Characters and Unicode

Total characters	118084
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	MALE
2nd row	MALE
3rd row	MALE
4th row	MALE
5th row	MALE

Common Values

Value	Count	Frequency (%)
MALE	27817	96.1%
FEMALE	1136	3.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
male	27817	96.1%
female	1136	3.9%

Most occurring characters

Value	Count	Frequency (%)
E	30089	25.5%
M	28953	24.5%
A	28953	24.5%
L	28953	24.5%
F	1136	1.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	118084	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	30089	25.5%
M	28953	24.5%
A	28953	24.5%
L	28953	24.5%
F	1136	1.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	118084	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	30089	25.5%
M	28953	24.5%
A	28953	24.5%
L	28953	24.5%
F	1136	1.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	118084	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	30089	25.5%
M	28953	24.5%
A	28953	24.5%
L	28953	24.5%
F	1136	1.0%

PAGE
Real number (ℝ)

Distinct	60
Distinct (%)	0.3%
Missing	7491
Missing (%)	25.9%
Infinite	0
Infinite (%)	0.0%
Mean	74.339763

Minimum	46
Maximum	111
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	226.3 KiB

Quantile statistics

Minimum	46
5-th percentile	61
Q1	68
median	74
Q3	80
95-th percentile	89
Maximum	111
Range	65
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	8.759284
Coefficient of variation (CV)	0.11782771
Kurtosis	0.11442876
Mean	74.339763
Median Absolute Deviation (MAD)	6
Skewness	0.27743578
Sum	1595480
Variance	76.725057
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
75	1195	4.1%
74	1045	3.6%
73	999	3.5%
71	949	3.3%
72	934	3.2%
79	933	3.2%
76	902	3.1%
69	876	3.0%
80	780	2.7%
67	776	2.7%
Other values (50)	12073	41.7%
(Missing)	7491	25.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
46	10	< 0.1%
48	2	< 0.1%
49	9	< 0.1%
51	10	< 0.1%
52	19	0.1%
53	31	0.1%
54	48	0.2%
55	43	0.1%
56	48	0.2%
57	94	0.3%

Value	Count	Frequency (%)
111	3	< 0.1%
108	4	< 0.1%
106	39	0.1%
105	6	< 0.1%
104	6	< 0.1%
102	14	< 0.1%
101	13	< 0.1%
100	42	0.1%
99	9	< 0.1%
98	45	0.2%

CUSIP
Categorical

Distinct	386
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Memory size	226.3 KiB

69331C10	138
28102010	124
80851310	118
20825C10	112
34537086	111
Other values (381)	28350

Length

Max length	8
Median length	8
Mean length	8
Min length	8

Characters and Unicode

Total characters	231624
Distinct characters	33
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	02376R10
2nd row	02376R10
3rd row	02376R10
4th row	02376R10
5th row	02376R10

Common Values

Value	Count	Frequency (%)
69331C10	138	0.5%
28102010	124	0.4%
80851310	118	0.4%
20825C10	112	0.4%
34537086	111	0.4%
12589610	109	0.4%
59511210	108	0.4%
02687478	107	0.4%
30161N10	106	0.4%
96945710	106	0.4%
Other values (376)	27814	96.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
69331c10	138	0.5%
28102010	124	0.4%
80851310	118	0.4%
20825c10	112	0.4%
34537086	111	0.4%
12589610	109	0.4%
59511210	108	0.4%
02687478	107	0.4%
30161n10	106	0.4%
96945710	106	0.4%
Other values (376)	27814	96.1%

Most occurring characters

Value	Count	Frequency (%)
0	48712	21.0%
1	43855	18.9%
4	18076	7.8%
3	17242	7.4%
2	16657	7.2%
6	16590	7.2%
5	16346	7.1%
7	15283	6.6%
8	15216	6.6%
9	13560	5.9%
Other values (23)	10087	4.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	221537	95.6%
Uppercase Letter	10087	4.4%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
G	1251	12.4%
L	864	8.6%
R	720	7.1%
E	711	7.0%
C	644	6.4%
H	625	6.2%
P	548	5.4%
T	501	5.0%
V	468	4.6%
F	430	4.3%
Other values (13)	3325	33.0%

Decimal Number

Value	Count	Frequency (%)
0	48712	22.0%
1	43855	19.8%
4	18076	8.2%
3	17242	7.8%
2	16657	7.5%
6	16590	7.5%
5	16346	7.4%
7	15283	6.9%
8	15216	6.9%
9	13560	6.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	221537	95.6%
Latin	10087	4.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
G	1251	12.4%
L	864	8.6%
R	720	7.1%
E	711	7.0%
C	644	6.4%
H	625	6.2%
P	548	5.4%
T	501	5.0%
V	468	4.6%
F	430	4.3%
Other values (13)	3325	33.0%

Common

Value	Count	Frequency (%)
0	48712	22.0%
1	43855	19.8%
4	18076	8.2%
3	17242	7.8%
2	16657	7.5%
6	16590	7.5%
5	16346	7.4%
7	15283	6.9%
8	15216	6.9%
9	13560	6.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	231624	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	48712	21.0%
1	43855	18.9%
4	18076	7.8%
3	17242	7.4%
2	16657	7.2%
6	16590	7.2%
5	16346	7.1%
7	15283	6.6%
8	15216	6.6%
9	13560	5.9%
Other values (23)	10087	4.4%

TICKER
Categorical

Distinct	386
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Memory size	226.3 KiB

PCG	138
EIX	124
SCHW	118
COP	112
F	111
Other values (381)	28350

Length

Max length	5
Median length	3
Mean length	3.0498739
Min length	1

Characters and Unicode

Total characters	88303
Distinct characters	27
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	AAL
2nd row	AAL
3rd row	AAL
4th row	AAL
5th row	AAL

Common Values

Value	Count	Frequency (%)
PCG	138	0.5%
EIX	124	0.4%
SCHW	118	0.4%
COP	112	0.4%
F	111	0.4%
CMS	109	0.4%
MU	108	0.4%
AIG	107	0.4%
EXC	106	0.4%
WMB	106	0.4%
Other values (376)	27814	96.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
pcg	138	0.5%
eix	124	0.4%
schw	118	0.4%
cop	112	0.4%
f	111	0.4%
cms	109	0.4%
mu	108	0.4%
aig	107	0.4%
exc	106	0.4%
wmb	106	0.4%
Other values (376)	27814	96.1%

Most occurring characters

Value	Count	Frequency (%)
A	6535	7.4%
C	6531	7.4%
M	5668	6.4%
T	5323	6.0%
S	5189	5.9%
E	4742	5.4%
P	4642	5.3%
L	4310	4.9%
R	4277	4.8%
N	4205	4.8%
Other values (17)	36881	41.8%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	88175	99.9%
Other Punctuation	128	0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	6535	7.4%
C	6531	7.4%
M	5668	6.4%
T	5323	6.0%
S	5189	5.9%
E	4742	5.4%
P	4642	5.3%
L	4310	4.9%
R	4277	4.9%
N	4205	4.8%
Other values (16)	36753	41.7%

Other Punctuation

Value	Count	Frequency (%)
.	128	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	88175	99.9%
Common	128	0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	6535	7.4%
C	6531	7.4%
M	5668	6.4%
T	5323	6.0%
S	5189	5.9%
E	4742	5.4%
P	4642	5.3%
L	4310	4.9%
R	4277	4.9%
N	4205	4.8%
Other values (16)	36753	41.7%

Common

Value	Count	Frequency (%)
.	128	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	88303	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	6535	7.4%
C	6531	7.4%
M	5668	6.4%
T	5323	6.0%
S	5189	5.9%
E	4742	5.4%
P	4642	5.3%
L	4310	4.9%
R	4277	4.8%
N	4205	4.8%
Other values (17)	36881	41.8%

NAICS
Real number (ℝ)

Distinct	178
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	354630.62

Minimum	42
Maximum	999977
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	226.3 KiB

Quantile statistics

Minimum	42
5-th percentile	2211
Q1	316210
median	334516
Q3	518210
95-th percentile	561450
Maximum	999977
Range	999935
Interquartile range (IQR)	202000

Descriptive statistics

Standard deviation	188315.87
Coefficient of variation (CV)	0.53101977
Kurtosis	0.057663453
Mean	354630.62
Median Absolute Deviation (MAD)	147595
Skewness	-0.40580918
Sum	1.026762 × 10¹⁰
Variance	3.5462867 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
522110	1465	5.1%
22111	1272	4.4%
2211	1116	3.9%
2111	806	2.8%
325412	792	2.7%
334413	779	2.7%
524126	713	2.5%
334516	493	1.7%
518210	479	1.7%
481111	419	1.4%
Other values (168)	20619	71.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
42	84	0.3%
315	103	0.4%
321	82	0.3%
325	84	0.3%
423	40	0.1%
621	76	0.3%
2111	806	2.8%
2211	1116	3.9%
3113	101	0.3%
3352	92	0.3%

Value	Count	Frequency (%)
999977	127	0.4%
812331	85	0.3%
722513	228	0.8%
722511	67	0.2%
721120	40	0.1%
721110	155	0.5%
622110	177	0.6%
621511	141	0.5%
621492	65	0.2%
621491	83	0.3%

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	CFOANN	EXECDIR	EXECRANK	CO_PER_ROL	CONAME	CEOANN	SALARY	PENSION_CHG	TOTAL_SEC	TOTAL_CURR	CHG_CTRL_PYMT	AGE	EXECRANKANN	TDC1	ALLOTHTOT	SAL_PCT	TOTAL_CURR_PCT	TOTAL_SEC_PCT	TDC1_PCT	COMMENT	GVKEY	EXECID	YEAR	BECAMECEO	JOINED_CO	REJOIN	LEFTOFC	LEFTCO	RELEFT	PCEO	PCFO	TITLE	REASON	EXEC_LNAME	EXEC_FNAME	GENDER	PAGE	CUSIP	TICKER	NAICS
0	NaN	1	NaN	1	AMERICAN AIRLINES GROUP INC	CEO	600.00	NaN	NaN	600.00	NaN	NaN	1.0	1013.471	87.634	NaN	NaN	NaN	NaN	NaN	1045	58	1992	1985-03-01	1973-04-01	NaN	1998-05-20	1998-12-31	NaN	NaN	NaN	chmn., pres. & CEO	RETIRED	Crandall	Robert	MALE	87.0	02376R10	AAL	481111
1	NaN	0	NaN	2	AMERICAN AIRLINES GROUP INC	NaN	468.75	NaN	NaN	468.75	NaN	NaN	NaN	1470.664	6.820	NaN	NaN	NaN	NaN	NaN	1045	3660	1992	NaN	NaN	NaN	NaN	2002-04-01	NaN	NaN	NaN	vice chairman	RETIRED	Baker	Robert	MALE	NaN	02376R10	AAL	481111
2	NaN	0	NaN	3	AMERICAN AIRLINES GROUP INC	NaN	468.75	NaN	NaN	468.75	NaN	NaN	NaN	1477.225	13.381	NaN	NaN	NaN	NaN	NaN	1045	3661	1992	1998-05-20	NaN	NaN	2003-04-24	2003-04-24	NaN	NaN	NaN	chairman & CEO	RESIGNED	Carty	Donald	MALE	76.0	02376R10	AAL	481111
3	NaN	0	NaN	4	AMERICAN AIRLINES GROUP INC	NaN	343.75	NaN	NaN	343.75	NaN	NaN	NaN	718.104	4.869	NaN	NaN	NaN	NaN	NaN	1045	3662	1992	NaN	NaN	NaN	NaN	2002-09-17	NaN	NaN	NaN	executive vp; executive vp-marketing & planning-American	RETIRED	Gunn	Michael	MALE	NaN	02376R10	AAL	481111
4	NaN	0	NaN	5	AMERICAN AIRLINES GROUP INC	NaN	343.75	NaN	NaN	343.75	NaN	NaN	NaN	747.463	34.228	NaN	NaN	NaN	NaN	NaN	1045	3663	1992	NaN	NaN	NaN	NaN	1995-01-15	NaN	NaN	NaN	sr. v-p	RETIRED	Hopper	Max	MALE	NaN	02376R10	AAL	481111
5	NaN	1	NaN	1	AMERICAN AIRLINES GROUP INC	CEO	600.00	NaN	NaN	600.00	NaN	58.0	1.0	1003.974	73.631	0.000	0.000	NaN	-0.937	NaN	1045	58	1993	1985-03-01	1973-04-01	NaN	1998-05-20	1998-12-31	NaN	NaN	NaN	chmn., pres. & CEO	RETIRED	Crandall	Robert	MALE	87.0	02376R10	AAL	481111
6	NaN	0	NaN	2	AMERICAN AIRLINES GROUP INC	NaN	491.25	NaN	NaN	491.25	NaN	NaN	2.0	1328.595	13.280	4.800	4.800	NaN	-9.660	NaN	1045	3660	1993	NaN	NaN	NaN	NaN	2002-04-01	NaN	NaN	NaN	vice chairman	RETIRED	Baker	Robert	MALE	NaN	02376R10	AAL	481111
7	NaN	0	NaN	3	AMERICAN AIRLINES GROUP INC	NaN	491.25	NaN	NaN	491.25	NaN	NaN	3.0	1328.696	13.381	4.800	4.800	NaN	-10.055	NaN	1045	3661	1993	1998-05-20	NaN	NaN	2003-04-24	2003-04-24	NaN	NaN	NaN	chairman & CEO	RESIGNED	Carty	Donald	MALE	76.0	02376R10	AAL	481111
8	NaN	0	NaN	4	AMERICAN AIRLINES GROUP INC	NaN	362.50	NaN	NaN	362.50	NaN	NaN	4.0	693.602	14.041	5.455	5.455	NaN	-3.412	NaN	1045	3662	1993	NaN	NaN	NaN	NaN	2002-09-17	NaN	NaN	NaN	executive vp; executive vp-marketing & planning-American	RETIRED	Gunn	Michael	MALE	NaN	02376R10	AAL	481111
9	NaN	0	NaN	5	AMERICAN AIRLINES GROUP INC	NaN	356.25	NaN	NaN	356.25	NaN	NaN	5.0	691.359	32.108	3.636	3.636	NaN	-7.506	NaN	1045	3663	1993	NaN	NaN	NaN	NaN	1995-01-15	NaN	NaN	NaN	sr. v-p	RETIRED	Hopper	Max	MALE	NaN	02376R10	AAL	481111

	CFOANN	EXECDIR	EXECRANK	CO_PER_ROL	CONAME	CEOANN	SALARY	BONUS	PENSION_CHG	TOTAL_SEC	TOTAL_CURR	CHG_CTRL_PYMT	AGE	EXECRANKANN	TDC1	ALLOTHTOT	ALLOTHPD	SAL_PCT	TOTAL_CURR_PCT	TOTAL_SEC_PCT	TDC1_PCT	COMMENT	GVKEY	EXECID	YEAR	BECAMECEO	JOINED_CO	REJOIN	LEFTOFC	LEFTCO	RELEFT	PCEO	PCFO	TITLE	REASON	EXEC_LNAME	EXEC_FNAME	GENDER	PAGE	CUSIP	TICKER	NAICS
28943	NaN	0	NaN	31869	CBRE GROUP INC	NaN	366.000	585.000	NaN	NaN	951.000	NaN	NaN	NaN	1341.758	0.000	0.000	21.069	47.028	NaN	NaN	NaN	260774	30555	2004	NaN	2002-01-23	NaN	NaN	NaN	NaN	NaN	NaN	Executive Chairman of Cbre-Asia Pacific	NaN	Blain	Robert	MALE	67.0	12504L10	CBRE	531312
28944	NaN	0	NaN	31870	CBRE GROUP INC	NaN	458.000	663.000	NaN	NaN	1121.000	NaN	NaN	NaN	1286.484	1.646	0.000	35.764	28.328	NaN	11.643	NaN	260774	30556	2004	NaN	2003-07-23	NaN	NaN	2005-06-30	NaN	NaN	NaN	former president-EMEA	RESIGNED	Froggatt	Alan	MALE	NaN	12504L10	CBRE	531312
28945	NaN	0	NaN	31871	CBRE GROUP INC	NaN	225.000	189.800	NaN	NaN	414.800	NaN	NaN	NaN	NaN	200.179	200.179	NaN	NaN	NaN	NaN	NaN	260774	30557	2004	NaN	2004-04-26	NaN	NaN	NaN	NaN	NaN	NaN	executive vp & general counsel	NaN	Midler	Laurence	MALE	58.0	12504L10	CBRE	531312
28946	NaN	1	NaN	31865	CBRE GROUP INC	CEO	608.463	1968.900	NaN	NaN	2577.363	NaN	46.0	1.0	3622.316	0.000	0.000	10.630	13.741	NaN	-4.564	NaN	260774	30552	2005	2005-06-01	NaN	NaN	2012-11-30	NaN	NaN	NaN	NaN	Director	NaN	White	W.	MALE	62.0	12504L10	CBRE	531312
28947	NaN	1	NaN	31866	CBRE GROUP INC	NaN	416.155	882.789	NaN	NaN	1298.944	NaN	62.0	2.0	1327.647	0.857	0.000	-35.976	-51.496	NaN	-65.307	NaN	260774	30553	2005	2001-09-01	NaN	NaN	2005-06-02	2007-06-02	NaN	NaN	NaN	former CEO	RETIRED	Wirta	Ray	MALE	79.0	12504L10	CBRE	531312
28948	NaN	0	NaN	31867	CBRE GROUP INC	NaN	450.000	592.200	NaN	NaN	1042.200	NaN	50.0	4.0	1555.000	0.000	0.000	0.000	8.337	NaN	13.372	NaN	260774	21562	2005	NaN	2002-06-13	NaN	NaN	2008-11-30	NaN	NaN	NaN	former senior executive vp & chief finance officer	RESIGNED	Kay	Kenneth	MALE	67.0	12504L10	CBRE	531312
28949	NaN	0	NaN	31868	CBRE GROUP INC	NaN	500.000	762.000	NaN	NaN	1262.000	NaN	49.0	3.0	1929.498	0.857	0.000	11.111	4.852	NaN	NaN	NaN	260774	30554	2005	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	Global Group President of Geographies	NaN	Frese, Jr.	Calvin	MALE	65.0	12504L10	CBRE	531312
28950	NaN	0	NaN	31869	CBRE GROUP INC	NaN	383.437	499.896	NaN	NaN	883.333	NaN	50.0	5.0	1541.615	0.000	0.000	4.764	-7.115	NaN	14.895	NaN	260774	30555	2005	NaN	2002-01-23	NaN	NaN	NaN	NaN	NaN	NaN	Executive Chairman of Cbre-Asia Pacific	NaN	Blain	Robert	MALE	67.0	12504L10	CBRE	531312
28951	NaN	0	NaN	31870	CBRE GROUP INC	NaN	389.250	472.290	NaN	NaN	861.540	NaN	NaN	6.0	863.033	1.493	0.000	-15.011	-23.145	NaN	-32.915	NaN	260774	30556	2005	NaN	2003-07-23	NaN	NaN	2005-06-30	NaN	NaN	NaN	former president-EMEA	RESIGNED	Froggatt	Alan	MALE	NaN	12504L10	CBRE	531312
28952	NaN	0	NaN	31871	CBRE GROUP INC	NaN	325.000	214.700	NaN	NaN	539.700	NaN	41.0	7.0	962.208	12.268	11.700	44.444	30.111	NaN	NaN	NaN	260774	30557	2005	NaN	2004-04-26	NaN	NaN	NaN	NaN	NaN	NaN	executive vp & general counsel	NaN	Midler	Laurence	MALE	58.0	12504L10	CBRE	531312

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Other Punctuation

Decimal Number

Space Separator

Dash Punctuation

Open Punctuation

Close Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Other Punctuation

Math Symbol

Space Separator

Currency Symbol

Dash Punctuation

Close Punctuation

Open Punctuation

Final Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common